<?php
class NoticeMsgReactionInfo extends AppModel {
	var $name = "NoticeMsgReactionInfo";
	var $useTable = "notice_msg_reaction_info";
	var $primaryKey = 'id';
	
	//会員が告知メールを削除する
	function doDelete($id) {
		$sql = "update notice_msg_reaction_info set member_deleted=now()  - interval '1 hour' " . " where id in (".Sanitize::sql($id).")";
		$this->query($sql);
	}
	
	//閲覧済みへ更新
	function updateReadedStatus($id) {
		$sql = "update notice_msg_reaction_info set status='1' " . " where id = " . Sanitize::sql($id) . " and status='0' ";
		$this->query($sql);
	}
}

?>